Budget Group
|
Operating Budgets, Common Agricultural Examples
|
Budget
|
7- Corn and Soybean Same Year Machinery Stock Analysis
|
Costs
|
1252050.000 |
126206.000 |
66361.156 |
3380.915 |
71500.000 |
7700.000 |
149000.000 |
3300.000 |
268.000 |
238.000 |
12136.382 |
26.000 |
24547.380 |
2457.600 |
160.000 |
18935.970 |
48.505 |
113.000 |
245.649 |
35426.795 |
2340.000 |
1851.990 |
n.a.
|
79155.79 |
69742.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Time Period
|
Corn for Grain
|
Costs |
Market Value
|
Salvage Value
|
Cap Recov Cost
|
THI Cost
|
Starting Hrs
|
Planned Use Hrs
|
Useful Life Hrs
|
Horsepower
|
Speed
|
Width
|
Fuel Amount
|
Fuel Price
|
Fuel Cost
|
Labor Amount
|
Labor Price
|
Labor Cost
|
Lube Oil Amounts
|
Lube Oil Price
|
Lube Oil Cost
|
Repair Cost
|
Equiv PTO HP
|
Field Efficiency
|
Amount
|
Operating Cost
|
Alloc OH Cost
|
|
|
|
|
|
Labor Available (hours per day)
|
Area Covered (ac/ha per day)
|
Planned vs Actual Start Date
|
Probable Field Days Needed
|
Probable Finish Date
|
Timeliness Penalty Days From Start
|
Timeliness Penalty (percent)
|
Additional Penalty (percent)
|
Timeliness Penalty Cost (currency)
|
Timeliness Penalty Cost Per Hour
|
Operation
|
Chisel Plow
|
Costs
|
129100.000 |
12300.000 |
3396.494 |
295.608 |
7000.000 |
600.000 |
14000.000 |
330.000 |
25.000 |
20.000 |
930.337 |
2.000 |
1860.673 |
203.700 |
12.000 |
1330.607 |
4.423 |
10.000 |
22.999 |
2724.672 |
200.000 |
184.000 |
n.a.
|
5938.95 |
3692.10 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
|
Costs
|
13100.00 |
1300.00 |
1350.4243 |
107.0977 |
1000 |
100 |
2000 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
944.5084 |
100 |
85.0000 |
0.1941 |
944.51 |
1457.52 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
|
Costs
|
116000.00 |
11000.00 |
2046.0695 |
188.5098 |
6000 |
500 |
12000 |
190 |
20.0000 |
10.0000 |
930.3367 |
2.0000 |
1860.6734 |
106.7000 |
12.00 |
1330.6072 |
4.4232 |
5.0000 |
22.9987 |
1780.1634 |
100 |
99.0000 |
0.1941 |
4994.44 |
2234.58 |
|
|
|
|
|
Operation
|
Plant, Corn Grain, medium tractor, Example 1
|
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
|
Costs
|
14000.00 |
1400.00 |
1919.2068 |
50.1480 |
750 |
200 |
1500 |
140 |
5.0000 |
14.0000 |
0.0000 |
0.0000 |
0.0000 |
92.4000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
1033.2000 |
100 |
70.0000 |
0.1684 |
1033.20 |
1969.35 |
|
|
|
|
|
Input : Seed, grain
|
Input : Example 1- Tractor, New Calculators
|
Costs
|
53610.00 |
7566.00 |
1140.4344 |
51.3828 |
0 |
300 |
6000 |
140 |
5.0000 |
10.0000 |
697.3680 |
2.0000 |
1394.7360 |
92.4000 |
12.00 |
1108.8000 |
2.9484 |
3.0000 |
8.8536 |
208.0512 |
100 |
80.0000 |
0.1684 |
2720.44 |
1191.82 |
|
|
|
|
|
Operation
|
Apply Anyhdrous
|
Costs
|
84100.000 |
8400.000 |
319.765 |
29.698 |
6000.000 |
500.000 |
12000.000 |
150.000 |
20.000 |
10.000 |
238.365 |
2.000 |
495.424 |
23.100 |
12.000 |
288.070 |
0.781 |
5.000 |
4.064 |
279.411 |
140.000 |
99.000 |
n.a.
|
1066.97 |
349.46 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
319.7649 |
29.6982 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
238.3647 |
2.0000 |
495.4236 |
23.1000 |
12.00 |
288.0696 |
0.7812 |
5.0000 |
4.0635 |
279.4113 |
140 |
99.0000 |
0.0417 |
1066.97 |
349.46 |
|
|
|
|
|
Input : Anhydrous Applicator Rental
|
Input : Fertilizer, Anhydrous Ammonia
|
Operation
|
Field Cultivate
|
Costs
|
90430.000 |
9000.000 |
1501.617 |
116.906 |
7000.000 |
700.000 |
14000.000 |
290.000 |
27.000 |
20.000 |
591.883 |
2.000 |
1183.766 |
145.950 |
12.000 |
953.373 |
2.585 |
10.000 |
13.448 |
1260.577 |
200.000 |
184.000 |
n.a.
|
3411.16 |
1618.52 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Cultivator, Row Crop, 6 Row
|
Costs
|
6330.00 |
600.00 |
443.3475 |
18.6191 |
1000 |
200 |
2000 |
140 |
7.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
69.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
335.8588 |
100 |
85.0000 |
0.1387 |
335.86 |
461.97 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1058.2696 |
98.2869 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
591.8829 |
2.0000 |
1183.7657 |
76.4500 |
12.00 |
953.3732 |
2.5854 |
5.0000 |
13.4483 |
924.7184 |
100 |
99.0000 |
0.1387 |
3075.31 |
1156.56 |
|
|
|
|
|
Operation
|
Weed Control, corn grain
|
Costs
|
39490.000 |
3900.000 |
1503.021 |
37.304 |
6750.000 |
700.000 |
13500.000 |
220.000 |
26.500 |
20.000 |
1260.002 |
2.000 |
2520.005 |
195.000 |
16.000 |
1606.108 |
1.502 |
10.000 |
7.712 |
991.507 |
200.000 |
65.990 |
n.a.
|
5125.33 |
1540.32 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
|
Costs
|
5890.00 |
600.00 |
935.3858 |
24.5310 |
750 |
200 |
1500 |
140 |
6.5000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
501.5985 |
100 |
65.0000 |
0.1953 |
501.60 |
959.92 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 70-89 PTO HP
|
Costs
|
33600.00 |
3300.00 |
567.6353 |
12.7725 |
6000 |
500 |
12000 |
80 |
20.0000 |
10.0000 |
1260.0023 |
2.0000 |
2520.0045 |
97.5000 |
16.00 |
1606.1078 |
1.5015 |
5.0000 |
7.7123 |
489.9083 |
100 |
0.9900 |
0.1953 |
4623.73 |
580.41 |
|
|
|
|
|
Input : EPTC (Eptan), 7E-(Eradicane), 6-7#-GAL EC
|
Operation
|
Combine, corn grain
|
Input : Combine, Self Propelled with Grain Head, Large capacity
|
Costs
|
159000.00 |
16000.00 |
20868.9288 |
885.7041 |
1500 |
300 |
3000 |
140 |
3.0000 |
10.0000 |
1631.3430 |
2.0000 |
3390.6468 |
216.1500 |
12.00 |
2695.5084 |
6.8972 |
5.0000 |
35.8613 |
8799.5058 |
100 |
70.0000 |
0.3929 |
14921.52 |
21754.63 |
|
|
|
|
|
Operation
|
Haul, corn grain
|
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1466.8881 |
136.2583 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
1054.3540 |
2.0000 |
2108.7080 |
139.7000 |
12.00 |
1742.1352 |
4.4577 |
5.0000 |
23.1775 |
1281.8999 |
100 |
99.0000 |
0.2538 |
5155.92 |
1603.15 |
|
|
|
|
|
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
|
Costs
|
4200.00 |
400.00 |
874.8141 |
22.6568 |
750 |
200 |
1500 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
127.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
571.9826 |
100 |
65.0000 |
0.2538 |
571.98 |
897.47 |
|
|
|
|
|
Time Period Totals
|
Time Period
|
Soybeans for Grain
|
Costs |
Market Value
|
Salvage Value
|
Cap Recov Cost
|
THI Cost
|
Starting Hrs
|
Planned Use Hrs
|
Useful Life Hrs
|
Horsepower
|
Speed
|
Width
|
Fuel Amount
|
Fuel Price
|
Fuel Cost
|
Labor Amount
|
Labor Price
|
Labor Cost
|
Lube Oil Amounts
|
Lube Oil Price
|
Lube Oil Cost
|
Repair Cost
|
Equiv PTO HP
|
Field Efficiency
|
Amount
|
Operating Cost
|
Alloc OH Cost
|
|
|
|
|
|
Labor Available (hours per day)
|
Area Covered (ac/ha per day)
|
Planned vs Actual Start Date
|
Probable Field Days Needed
|
Probable Finish Date
|
Timeliness Penalty Days From Start
|
Timeliness Penalty (percent)
|
Additional Penalty (percent)
|
Timeliness Penalty Cost (currency)
|
Timeliness Penalty Cost Per Hour
|
Operation
|
Chisel Plow
|
Costs
|
129100.000 |
12300.000 |
3396.494 |
295.608 |
7000.000 |
600.000 |
14000.000 |
330.000 |
25.000 |
20.000 |
930.337 |
2.000 |
1860.673 |
203.700 |
12.000 |
1330.607 |
4.423 |
10.000 |
22.999 |
2724.672 |
200.000 |
184.000 |
n.a.
|
5938.95 |
3692.10 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
|
Costs
|
13100.00 |
1300.00 |
1350.4243 |
107.0977 |
1000 |
100 |
2000 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
944.5084 |
100 |
85.0000 |
0.1941 |
944.51 |
1457.52 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
|
Costs
|
116000.00 |
11000.00 |
2046.0695 |
188.5098 |
6000 |
500 |
12000 |
190 |
20.0000 |
10.0000 |
930.3367 |
2.0000 |
1860.6734 |
106.7000 |
12.00 |
1330.6072 |
4.4232 |
5.0000 |
22.9987 |
1780.1634 |
100 |
99.0000 |
0.1941 |
4994.44 |
2234.58 |
|
|
|
|
|
Operation
|
Seeding and Planting, soybeans
|
Input : Seed, soybeans
|
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
|
Costs
|
14000.00 |
1400.00 |
1919.2068 |
50.1480 |
750 |
200 |
1500 |
140 |
5.0000 |
14.0000 |
0.0000 |
0.0000 |
0.0000 |
92.4000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
1033.2000 |
100 |
70.0000 |
0.1684 |
1033.20 |
1969.35 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1279.0596 |
118.7928 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
715.3692 |
2.0000 |
1430.7384 |
92.4000 |
12.00 |
1152.2784 |
3.1248 |
5.0000 |
16.2540 |
1117.6452 |
100 |
99.0000 |
0.1684 |
3716.92 |
1397.85 |
|
|
|
|
|
Operation
|
Field Cultivate
|
Costs
|
90430.000 |
9000.000 |
1501.617 |
116.906 |
7000.000 |
700.000 |
14000.000 |
290.000 |
27.000 |
20.000 |
591.883 |
2.000 |
1183.766 |
145.950 |
12.000 |
953.373 |
2.585 |
10.000 |
13.448 |
1260.577 |
200.000 |
184.000 |
n.a.
|
3411.16 |
1618.52 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Cultivator, Row Crop, 6 Row
|
Costs
|
6330.00 |
600.00 |
443.3475 |
18.6191 |
1000 |
200 |
2000 |
140 |
7.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
69.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
335.8588 |
100 |
85.0000 |
0.1387 |
335.86 |
461.97 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1058.2696 |
98.2869 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
591.8829 |
2.0000 |
1183.7657 |
76.4500 |
12.00 |
953.3732 |
2.5854 |
5.0000 |
13.4483 |
924.7184 |
100 |
99.0000 |
0.1387 |
3075.31 |
1156.56 |
|
|
|
|
|
Operation
|
Weed Control, soybeans
|
Costs
|
69690.000 |
6980.000 |
2062.979 |
129.176 |
6750.000 |
700.000 |
13500.000 |
280.000 |
26.500 |
20.000 |
809.445 |
2.000 |
1618.890 |
204.900 |
12.000 |
1337.466 |
3.422 |
10.000 |
17.794 |
1486.506 |
200.000 |
164.000 |
n.a.
|
4460.66 |
2192.16 |
|
|
|
|
|
|
|
--- |
|
|
|
|
|
|
|
Input : Glyphosate (Roundup), 4#-GAL EC, 2003
|
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
|
Costs
|
5890.00 |
600.00 |
936.8248 |
24.5687 |
750 |
200 |
1500 |
140 |
6.5000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.6500 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
502.3702 |
100 |
65.0000 |
0.1953 |
502.37 |
961.39 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1126.1543 |
104.6078 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
809.4450 |
2.0000 |
1618.8900 |
107.2500 |
12.00 |
1337.4660 |
3.4223 |
5.0000 |
17.7938 |
984.1358 |
100 |
99.0000 |
0.1953 |
3958.29 |
1230.76 |
|
|
|
|
|
Operation
|
Combine, soybeans
|
Input : Combine, Self Propelled with Grain Head, Large capacity
|
Costs
|
159000.00 |
16000.00 |
20868.9288 |
885.7041 |
1500 |
300 |
3000 |
140 |
3.0000 |
10.0000 |
1631.3430 |
2.0000 |
3390.6468 |
216.1500 |
12.00 |
2695.5084 |
6.8972 |
5.0000 |
35.8613 |
8799.5058 |
100 |
70.0000 |
0.3929 |
14921.52 |
21754.63 |
|
|
|
|
|
Operation
|
Haul beans, soybean
|
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1466.8881 |
136.2583 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
1054.3540 |
2.0000 |
2108.7080 |
139.7000 |
12.00 |
1742.1352 |
4.4577 |
5.0000 |
23.1775 |
1281.8999 |
100 |
99.0000 |
0.2538 |
5155.92 |
1603.15 |
|
|
|
|
|
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
|
Costs
|
4200.00 |
400.00 |
874.8141 |
22.6568 |
750 |
200 |
1500 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
127.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
571.9826 |
100 |
65.0000 |
0.2538 |
571.98 |
897.47 |
|
|
|
|
|
Time Period Totals
|